Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	280
Missing cells	197
Missing cells (%)	4.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	32.9 KiB
Average record size in memory	120.5 B

Variable types

Numeric	13
Categorical	2

Alerts

`Province/State` has a high cardinality: 87 distinct values	High cardinality
`Country/Region` has a high cardinality: 196 distinct values	High cardinality
`1/24/2022` is highly correlated with `1/25/2022` and 8 other fields	High correlation
`1/25/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/26/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/27/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/28/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/29/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/30/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/31/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/1/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/2/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/24/2022` is highly correlated with `1/25/2022` and 8 other fields	High correlation
`1/25/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/26/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/27/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/28/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/29/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/30/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/31/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/1/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/2/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/24/2022` is highly correlated with `1/25/2022` and 8 other fields	High correlation
`1/25/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/26/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/27/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/28/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/29/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/30/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/31/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/1/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/2/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`Unnamed: 0` is highly correlated with `Province/State` and 1 other fields	High correlation
`Province/State` is highly correlated with `Unnamed: 0` and 2 other fields	High correlation
`Lat` is highly correlated with `Province/State` and 1 other fields	High correlation
`Long` is highly correlated with `Unnamed: 0` and 2 other fields	High correlation
`1/24/2022` is highly correlated with `1/25/2022` and 8 other fields	High correlation
`1/25/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/26/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/27/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/28/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/29/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/30/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`1/31/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/1/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`2/2/2022` is highly correlated with `1/24/2022` and 8 other fields	High correlation
`Province/State` has 193 (68.9%) missing values	Missing
`Unnamed: 0` is uniformly distributed	Uniform
`Province/State` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`Lat` has 4 (1.4%) zeros	Zeros
`Long` has 4 (1.4%) zeros	Zeros

Reproduction

Analysis started	2022-02-04 03:59:03.799729
Analysis finished	2022-02-04 03:59:27.442920
Duration	23.64 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	280
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	139.5

Minimum	0
Maximum	279
Zeros	1
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	13.95
Q1	69.75
median	139.5
Q3	209.25
95-th percentile	265.05
Maximum	279
Range	279
Interquartile range (IQR)	139.5

Descriptive statistics

Standard deviation	80.97324661
Coefficient of variation (CV)	0.5804533807
Kurtosis	-1.2
Mean	139.5
Median Absolute Deviation (MAD)	70
Skewness	0
Sum	39060
Variance	6556.666667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	0.4%
184	1	0.4%
190	1	0.4%
189	1	0.4%
188	1	0.4%
187	1	0.4%
186	1	0.4%
185	1	0.4%
183	1	0.4%
192	1	0.4%
Other values (270)	270	96.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.4%
1	1	0.4%
2	1	0.4%
3	1	0.4%
4	1	0.4%
5	1	0.4%
6	1	0.4%
7	1	0.4%
8	1	0.4%
9	1	0.4%

Value	Count	Frequency (%)
279	1	0.4%
278	1	0.4%
277	1	0.4%
276	1	0.4%
275	1	0.4%
274	1	0.4%
273	1	0.4%
272	1	0.4%
271	1	0.4%
270	1	0.4%

Province/State
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING
UNIFORM

Distinct	87
Distinct (%)	100.0%
Missing	193
Missing (%)	68.9%
Memory size	2.3 KiB

Australian Capital Territory	1
Martinique	1
Guadeloupe	1
French Polynesia	1
French Guiana	1
Other values (82)	82

Length

Max length	44
Median length	9
Mean length	11.40229885
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	87 ?
Unique (%)	100.0%

Sample

1st row	Australian Capital Territory
2nd row	New South Wales
3rd row	Northern Territory
4th row	Queensland
5th row	South Australia

Common Values

Value	Count	Frequency (%)
Australian Capital Territory	1	0.4%
Martinique	1	0.4%
Guadeloupe	1	0.4%
French Polynesia	1	0.4%
French Guiana	1	0.4%
Greenland	1	0.4%
Faroe Islands	1	0.4%
Zhejiang	1	0.4%
Yunnan	1	0.4%
Xinjiang	1	0.4%
Other values (77)	77	27.5%
(Missing)	193	68.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
islands	7	5.0%
and	6	4.3%
saint	3	2.1%
new	3	2.1%
south	2	1.4%
sint	2	1.4%
australia	2	1.4%
british	2	1.4%
french	2	1.4%
princess	2	1.4%
Other values (109)	110	78.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Country/Region
Categorical

HIGH CARDINALITY

Distinct	196
Distinct (%)	70.0%
Missing	0
Missing (%)	0.0%
Memory size	2.3 KiB

China	34
Canada	16
United Kingdom	12
France	12
Australia	8
Other values (191)	198

Length

Max length	32
Median length	7
Mean length	8.139285714
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	188 ?
Unique (%)	67.1%

Sample

1st row	Afghanistan
2nd row	Albania
3rd row	Algeria
4th row	Andorra
5th row	Angola

Common Values

Value	Count	Frequency (%)
China	34	12.1%
Canada	16	5.7%
United Kingdom	12	4.3%
France	12	4.3%
Australia	8	2.9%
Netherlands	5	1.8%
Denmark	3	1.1%
New Zealand	2	0.7%
Panama	1	0.4%
Niger	1	0.4%
Other values (186)	186	66.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
china	34	9.9%
canada	16	4.7%
united	13	3.8%
kingdom	12	3.5%
france	12	3.5%
australia	8	2.3%
and	7	2.0%
netherlands	5	1.5%
denmark	3	0.9%
new	3	0.9%
Other values (220)	231	67.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Lat
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	274
Distinct (%)	98.6%
Missing	2
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	20.15604155

Minimum	-51.7963
Maximum	71.7069
Zeros	4
Zeros (%)	1.4%
Negative	55
Negative (%)	19.6%
Memory size	2.3 KiB

Quantile statistics

Minimum	-51.7963
5-th percentile	-26.664595
Q1	4.643279
median	21.51717
Q3	40.39335025
95-th percentile	55.200705
Maximum	71.7069
Range	123.5032
Interquartile range (IQR)	35.75007125

Descriptive statistics

Standard deviation	25.2833179
Coefficient of variation (CV)	1.254379132
Kurtosis	-0.3587458794
Mean	20.15604155
Median Absolute Deviation (MAD)	17.95728
Skewness	-0.4359189955
Sum	5603.37955
Variance	639.2461638
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4	1.4%
52.9399	2	0.7%
33.93911	1	0.4%
42.708678	1	0.4%
28.1667	1	0.4%
-22.9576	1	0.4%
-18.665695	1	0.4%
31.7917	1	0.4%
46.8625	1	0.4%
12.1784	1	0.4%
Other values (264)	264	94.3%
(Missing)	2	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-51.7963	1	0.4%
-42.8821	1	0.4%
-40.9006	1	0.4%
-38.4161	1	0.4%
-37.8136	1	0.4%
-35.6751	1	0.4%
-35.4735	1	0.4%
-34.9285	1	0.4%
-33.8688	1	0.4%
-32.5228	1	0.4%

Value	Count	Frequency (%)
71.7069	1	0.4%
70.2998	1	0.4%
64.9631	1	0.4%
64.8255	1	0.4%
64.2823	1	0.4%
61.92411	1	0.4%
61.8926	1	0.4%
61.52401	1	0.4%
60.472	1	0.4%
60.128161	1	0.4%

Long
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	275
Distinct (%)	98.9%
Missing	2
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	21.78895473

Minimum	-178.1165
Maximum	178.065
Zeros	4
Zeros (%)	1.4%
Negative	93
Negative (%)	33.2%
Memory size	2.3 KiB

Quantile statistics

Minimum	-178.1165
5-th percentile	-89.096645
Q1	-37.713675
median	20.9211885
Q3	84.992575
95-th percentile	140.4009775
Maximum	178.065
Range	356.1815
Interquartile range (IQR)	122.70625

Descriptive statistics

Standard deviation	76.20016892
Coefficient of variation (CV)	3.497192494
Kurtosis	-0.4988627293
Mean	21.78895473
Median Absolute Deviation (MAD)	63.9222
Skewness	-0.1476040244
Sum	6057.329414
Variance	5806.465744
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4	1.4%
7.4167	1	0.4%
84.25	1	0.4%
18.4904	1	0.4%
35.529562	1	0.4%
-7.0926	1	0.4%
19.37439	1	0.4%
103.8467	1	0.4%
67.709953	1	0.4%
-69.9683	1	0.4%
Other values (265)	265	94.6%
(Missing)	2	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-178.1165	1	0.4%
-175.1982	1	0.4%
-172.1046	1	0.4%
-168.734	1	0.4%
-159.7777	1	0.4%
-135	1	0.4%
-127.6476	1	0.4%
-124.8457	1	0.4%
-116.5765	1	0.4%
-106.4509	1	0.4%

Value	Count	Frequency (%)
178.065	1	0.4%
174.886	1	0.4%
171.1845	1	0.4%
166.9592	1	0.4%
165.618042	1	0.4%
160.1562	1	0.4%
153.0251	1	0.4%
151.2093	1	0.4%
150.5508	1	0.4%
149.4068	1	0.4%

1/24/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	275
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1268535.596

Minimum	0
Maximum	71783483
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	29.95
Q1	7280.5
median	63984.5
Q3	605076.5
95-th percentile	4554237.6
Maximum	71783483
Range	71783483
Interquartile range (IQR)	597796

Descriptive statistics

Standard deviation	5447710.697
Coefficient of variation (CV)	4.294487842
Kurtosis	110.6333879
Mean	1268535.596
Median Absolute Deviation (MAD)	63756
Skewness	9.607524292
Sum	355189967
Variance	2.967755183 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
7	2	0.7%
0	2	0.7%
13	2	0.7%
159896	1	0.4%
7691	1	0.4%
222652	1	0.4%
1101163	1	0.4%
213896	1	0.4%
430328	1	0.4%
Other values (265)	265	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
20	1	0.4%
29	1	0.4%
30	1	0.4%

Value	Count	Frequency (%)
71783483	1	0.4%
39799202	1	0.4%
24142032	1	0.4%
16446852	1	0.4%
15953685	1	0.4%
11014152	1	0.4%
10988027	1	0.4%
10001344	1	0.4%
9280890	1	0.4%
8909503	1	0.4%

1/25/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	275
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1281805.504

Minimum	0
Maximum	72333439
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	29.95
Q1	7423.75
median	64181
Q3	611787
95-th percentile	4591675.45
Maximum	72333439
Range	72333439
Interquartile range (IQR)	604363.25

Descriptive statistics

Standard deviation	5494230.917
Coefficient of variation (CV)	4.286321834
Kurtosis	110.2214282
Mean	1281805.504
Median Absolute Deviation (MAD)	63952.5
Skewness	9.585828067
Sum	358905541
Variance	3.018657337 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
7	2	0.7%
0	2	0.7%
13	2	0.7%
160252	1	0.4%
7790	1	0.4%
222892	1	0.4%
1107525	1	0.4%
215017	1	0.4%
433408	1	0.4%
Other values (265)	265	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
26	1	0.4%
29	1	0.4%
30	1	0.4%

Value	Count	Frequency (%)
72333439	1	0.4%
40085116	1	0.4%
24342322	1	0.4%
16948487	1	0.4%
16047716	1	0.4%
11090493	1	0.4%
11055246	1	0.4%
10212621	1	0.4%
9395767	1	0.4%
9088672	1	0.4%

1/26/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	275
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1295233.786

Minimum	0
Maximum	72980648
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	29.95
Q1	7583
median	64455.5
Q3	623113.25
95-th percentile	4642420.65
Maximum	72980648
Range	72980648
Interquartile range (IQR)	615530.25

Descriptive statistics

Standard deviation	5544259.445
Coefficient of variation (CV)	4.280508667
Kurtosis	110.0823882
Mean	1295233.786
Median Absolute Deviation (MAD)	64144
Skewness	9.57685628
Sum	362665460
Variance	3.07388128 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
7	2	0.7%
0	2	0.7%
13	2	0.7%
160692	1	0.4%
7790	1	0.4%
223112	1	0.4%
1114527	1	0.4%
215950	1	0.4%
435681	1	0.4%
Other values (265)	265	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
28	1	0.4%
29	1	0.4%
30	1	0.4%

Value	Count	Frequency (%)
72980648	1	0.4%
40371500	1	0.4%
24560093	1	0.4%
17310548	1	0.4%
16149319	1	0.4%
11167927	1	0.4%
11129318	1	0.4%
10383561	1	0.4%
9529320	1	0.4%
9317280	1	0.4%

1/27/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	273
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1308330.621

Minimum	0
Maximum	73465396
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	29.95
Q1	7588
median	65063
Q3	633146
95-th percentile	4699628.05
Maximum	73465396
Range	73465396
Interquartile range (IQR)	625558

Descriptive statistics

Standard deviation	5586263.727
Coefficient of variation (CV)	4.269764565
Kurtosis	109.6495402
Mean	1308330.621
Median Absolute Deviation (MAD)	64751.5
Skewness	9.55413241
Sum	366332574
Variance	3.120634243 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
29	2	0.7%
7	2	0.7%
0	2	0.7%
161	2	0.7%
13	2	0.7%
7790	1	0.4%
223413	1	0.4%
1120087	1	0.4%
216856	1	0.4%
Other values (263)	263	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
29	2	0.7%
30	1	0.4%
79	1	0.4%

Value	Count	Frequency (%)
73465396	1	0.4%
40622709	1	0.4%
24789795	1	0.4%
17696796	1	0.4%
16245474	1	0.4%
11250107	1	0.4%
11217423	1	0.4%
10539601	1	0.4%
9660208	1	0.4%
9477603	1	0.4%

1/28/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	274
Distinct (%)	97.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1321258.539

Minimum	0
Maximum	74063641
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	29.95
Q1	7595
median	65826.5
Q3	645241.5
95-th percentile	4758743.05
Maximum	74063641
Range	74063641
Interquartile range (IQR)	637646.5

Descriptive statistics

Standard deviation	5633267.941
Coefficient of variation (CV)	4.263562182
Kurtosis	109.4519608
Mean	1321258.539
Median Absolute Deviation (MAD)	65514.5
Skewness	9.541996065
Sum	369952391
Variance	3.173370769 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
29	2	0.7%
7	2	0.7%
0	2	0.7%
13	2	0.7%
8183	1	0.4%
155722	1	0.4%
223612	1	0.4%
1124986	1	0.4%
217752	1	0.4%
Other values (264)	264	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
29	2	0.7%
30	1	0.4%
79	1	0.4%

Value	Count	Frequency (%)
74063641	1	0.4%
40858241	1	0.4%
25050601	1	0.4%
18048584	1	0.4%
16333980	1	0.4%
11343693	1	0.4%
11314707	1	0.4%
10683948	1	0.4%
9779130	1	0.4%
9661657	1	0.4%

1/29/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	274
Distinct (%)	97.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1330534.014

Minimum	0
Maximum	74232238
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	7605.25
median	65921.5
Q3	651969
95-th percentile	4809977.65
Maximum	74232238
Range	74232238
Interquartile range (IQR)	644363.75

Descriptive statistics

Standard deviation	5657957.555
Coefficient of variation (CV)	4.252396026
Kurtosis	108.649979
Mean	1330534.014
Median Absolute Deviation (MAD)	65693.5
Skewness	9.504590895
Sum	372549524
Variance	3.201248369 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
7	2	0.7%
0	2	0.7%
13	2	0.7%
30	2	0.7%
161290	1	0.4%
438249	1	0.4%
1129140	1	0.4%
218637	1	0.4%
442186	1	0.4%
Other values (264)	264	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
29	1	0.4%
30	2	0.7%
79	1	0.4%

Value	Count	Frequency (%)
74232238	1	0.4%
41092522	1	0.4%
25256198	1	0.4%
18380982	1	0.4%
16406123	1	0.4%
11438476	1	0.4%
11427009	1	0.4%
10821375	1	0.4%
9779130	1	0.4%
9774847	1	0.4%

1/30/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	274
Distinct (%)	97.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1338493.611

Minimum	0
Maximum	74424305
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	7613
median	66017
Q3	657573.25
95-th percentile	4856546.6
Maximum	74424305
Range	74424305
Interquartile range (IQR)	649960.25

Descriptive statistics

Standard deviation	5680180.306
Coefficient of variation (CV)	4.243711184
Kurtosis	108.1432986
Mean	1338493.611
Median Absolute Deviation (MAD)	65788
Skewness	9.48058053
Sum	374778211
Variance	3.226444831 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
7	2	0.7%
0	2	0.7%
13	2	0.7%
30	2	0.7%
162111	1	0.4%
438249	1	0.4%
1131395	1	0.4%
219303	1	0.4%
443392	1	0.4%
Other values (264)	264	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
29	1	0.4%
30	2	0.7%
79	1	0.4%

Value	Count	Frequency (%)
74424305	1	0.4%
41302440	1	0.4%
25360647	1	0.4%
18630430	1	0.4%
16468522	1	0.4%
11547333	1	0.4%
11526621	1	0.4%
10925485	1	0.4%
9846032	1	0.4%
9779130	1	0.4%

1/31/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	275
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1351399.532

Minimum	0
Maximum	74951445
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	31.9
Q1	7740
median	67695
Q3	660958.75
95-th percentile	4888975.8
Maximum	74951445
Range	74951445
Interquartile range (IQR)	653218.75

Descriptive statistics

Standard deviation	5724079.153
Coefficient of variation (CV)	4.235667555
Kurtosis	107.7465791
Mean	1351399.532
Median Absolute Deviation (MAD)	67376.5
Skewness	9.456784718
Sum	378391869
Variance	3.276508215 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
7	2	0.7%
0	2	0.7%
13	2	0.7%
162926	1	0.4%
8183	1	0.4%
223827	1	0.4%
1132716	1	0.4%
219775	1	0.4%
444588	1	0.4%
Other values (265)	265	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
29	1	0.4%
30	1	0.4%
32	1	0.4%

Value	Count	Frequency (%)
74951445	1	0.4%
41469499	1	0.4%
25463530	1	0.4%
18713087	1	0.4%
17315893	1	0.4%
11670366	1	0.4%
11619882	1	0.4%
10983116	1	0.4%
10025463	1	0.4%
9961253	1	0.4%

2/1/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	275
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1363156.643

Minimum	0
Maximum	75350359
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	31.9
Q1	7740
median	68143
Q3	667739.25
95-th percentile	4928290.95
Maximum	75350359
Range	75350359
Interquartile range (IQR)	659999.25

Descriptive statistics

Standard deviation	5759551.991
Coefficient of variation (CV)	4.225157851
Kurtosis	107.3136391
Mean	1363156.643
Median Absolute Deviation (MAD)	67738
Skewness	9.432953315
Sum	381683860
Variance	3.317243914 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3	1.1%
7	2	0.7%
0	2	0.7%
13	2	0.7%
163555	1	0.4%
8183	1	0.4%
223949	1	0.4%
1135796	1	0.4%
220597	1	0.4%
446076	1	0.4%
Other values (265)	265	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	3	1.1%
2	1	0.4%
4	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
29	1	0.4%
30	1	0.4%
32	1	0.4%

Value	Count	Frequency (%)
75350359	1	0.4%
41630885	1	0.4%
25634781	1	0.4%
19112755	1	0.4%
17428345	1	0.4%
11795059	1	0.4%
11722483	1	0.4%
11116422	1	0.4%
10236740	1	0.4%
10039126	1	0.4%

2/2/2022
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	275
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1374497.261

Minimum	0
Maximum	75680487
Zeros	2
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	0
5-th percentile	32.85
Q1	7797.5
median	68256.5
Q3	675358.75
95-th percentile	4981539.4
Maximum	75680487
Range	75680487
Interquartile range (IQR)	667561.25

Descriptive statistics

Standard deviation	5790886.629
Coefficient of variation (CV)	4.213094339
Kurtosis	106.8389889
Mean	1374497.261
Median Absolute Deviation (MAD)	67851.5
Skewness	9.407782195
Sum	384859233
Variance	3.353436795 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	2	0.7%
1	2	0.7%
0	2	0.7%
13	2	0.7%
37426	2	0.7%
164190	1	0.4%
446770	1	0.4%
156044	1	0.4%
224043	1	0.4%
1138847	1	0.4%
Other values (265)	265	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.7%
1	2	0.7%
2	1	0.4%
4	1	0.4%
5	1	0.4%
7	2	0.7%
9	1	0.4%
13	2	0.7%
29	1	0.4%
30	1	0.4%

Value	Count	Frequency (%)
75680487	1	0.4%
41803318	1	0.4%
25820745	1	0.4%
19378646	1	0.4%
17515199	1	0.4%
11936064	1	0.4%
11833165	1	0.4%
11235745	1	0.4%
10474992	1	0.4%
10125348	1	0.4%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	Province/State	Country/Region	Lat	Long	1/24/2022	1/25/2022	1/26/2022	1/27/2022	1/28/2022	1/29/2022	1/30/2022	1/31/2022	2/1/2022	2/2/2022
0	0	NaN	Afghanistan	33.93911	67.709953	159896	160252	160692	161004	161057	161290	162111	162926	163555	164190
1	1	NaN	Albania	41.15330	20.168300	248070	248859	251015	252577	254126	254126	255741	258543	258543	261240
2	2	NaN	Algeria	28.03390	1.659600	238885	241406	243568	245698	247568	249310	250774	252117	253520	254885
3	3	NaN	Andorra	42.50630	1.521800	33025	34701	35028	35028	35556	35556	35556	35958	35958	36315
4	4	NaN	Angola	-11.20270	17.873900	97263	97594	97812	97901	98029	98057	98076	98116	98226	98267
5	5	NaN	Antigua and Barbuda	17.06080	-61.796400	6023	6023	6442	6524	6558	6558	6558	6627	6627	6732
6	6	NaN	Argentina	-38.41610	-63.616700	7940657	8041520	8130023	8207752	8271636	8313614	8335184	8378656	8427778	8472848
7	7	NaN	Armenia	40.06910	45.038200	352399	353731	355662	358218	361754	364348	366433	367795	370922	374878
8	8	Australian Capital Territory	Australia	-35.47350	149.012400	31941	33071	33933	34418	34976	35520	36031	36474	37023	37426
9	9	New South Wales	Australia	-33.86880	151.209300	994277	1015495	1033364	1083622	1103219	1121481	1139787	1086483	1098290	1110567

Last rows

	Unnamed: 0	Province/State	Country/Region	Lat	Long	1/24/2022	1/25/2022	1/26/2022	1/27/2022	1/28/2022	1/29/2022	1/30/2022	1/31/2022	2/1/2022	2/2/2022
270	270	NaN	United Kingdom	55.378100	-3.436000	15953685	16047716	16149319	16245474	16333980	16406123	16468522	17315893	17428345	17515199
271	271	NaN	Uruguay	-32.522800	-55.765800	599040	609785	621453	631019	644631	653853	661441	668425	679878	690496
272	272	NaN	Uzbekistan	41.377491	64.585262	215063	216186	217360	218477	219663	220815	221919	223008	224023	225110
273	273	NaN	Vanuatu	-15.376700	166.959200	7	7	7	7	7	7	7	7	7	7
274	274	NaN	Venezuela	6.423800	-66.589700	469566	471389	475135	477022	479011	481375	484021	485974	485974	487775
275	275	NaN	Vietnam	14.058324	108.277199	2155784	2171527	2187481	2203208	2218137	2233287	2263053	2275727	2286750	2295494
276	276	NaN	West Bank and Gaza	31.952200	35.233200	484979	488599	492694	500444	504992	504992	504992	524716	535160	546176
277	277	NaN	Yemen	15.552727	48.516388	10585	10585	10821	10888	10942	10942	10942	11019	11061	11113
278	278	NaN	Zambia	-13.133897	27.849332	301924	302569	303266	304002	304353	304656	304922	305047	305557	305959
279	279	NaN	Zimbabwe	-19.015438	29.154857	228541	228776	228943	229096	229333	229415	229460	229666	229851	230012

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows